Tabela PhAuction

Definicja tabeli PhAuction

Name

PhAuction

Code

PhAuction

Comment

Przetarg


Lista kolumn tabeli PhAuction

Name

Code

AuctionID

AuctionID

AuctionNo

AuctionNo

Name

Name

StatusID

StatusID

Info

Info

CpvID

CpvID

Active

Active

AuctionDt

AuctionDt

StartDT

StartDT

StopDT

StopDT

PaymentPeriodQuantity

PaymentPeriodQuantity

PaymentPeriodUnitID

PaymentPeriodUnitID

RealizationPeriodQuantity

RealizationPeriodQuantity

RealizationPeriodUnitID

RealizationPeriodUnitID


Kolumna AuctionID tabeli PhAuction

Definicja kolumny AuctionID tabeli PhAuction

Name

AuctionID

Code

AuctionID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

Klucz


Kolumna AuctionNo tabeli PhAuction

Definicja kolumny AuctionNo tabeli PhAuction

Name

AuctionNo

Code

AuctionNo

Data Type

VARCHAR2(255)

Mandatory

No

Comment

Numer przetargu


Kolumna Name tabeli PhAuction

Definicja kolumny Name tabeli PhAuction

Name

Name

Code

Name

Data Type

VARCHAR2(255)

Mandatory

No

Comment

Nazwa przetargu


Kolumna StatusID tabeli PhAuction

Definicja kolumny StatusID tabeli PhAuction

Name

StatusID

Code

StatusID

Data Type

NUMBER(10)

Mandatory

No

Comment

Status przetargu fk do PhAuctionStatus


Kolumna Info tabeli PhAuction

Definicja kolumny Info tabeli PhAuction

Name

Info

Code

Info

Data Type

VARCHAR2(255)

Mandatory

No

Comment

Komentarz do przetargu


Kolumna CpvID tabeli PhAuction

Definicja kolumny CpvID tabeli PhAuction

Name

CpvID

Code

CpvID

Data Type

NUMBER(10)

Mandatory

No

Comment

Kod cpv fk do PhCpv


Kolumna Active tabeli PhAuction

Definicja kolumny Active tabeli PhAuction

Name

Active

Code

Active

Data Type

NUMBER(3)

Mandatory

Yes

Comment

czy aktywny


Kolumna AuctionDt tabeli PhAuction

Definicja kolumny AuctionDt tabeli PhAuction

Name

AuctionDt

Code

AuctionDt

Data Type

DATE

Mandatory

No

Comment

Data opublikowania przetagru


Kolumna StartDT tabeli PhAuction

Definicja kolumny StartDT tabeli PhAuction

Name

StartDT

Code

StartDT

Data Type

DATE

Mandatory

No

Comment

Data poczatku dostaw towarów


Kolumna StopDT tabeli PhAuction

Definicja kolumny StopDT tabeli PhAuction

Name

StopDT

Code

StopDT

Data Type

DATE

Mandatory

No

Comment

Data konca dostaw towarów


Kolumna PaymentPeriodQuantity tabeli PhAuction

Definicja kolumny PaymentPeriodQuantity tabeli PhAuction

Name

PaymentPeriodQuantity

Code

PaymentPeriodQuantity

Data Type

NUMBER(10)

Mandatory

No

Comment

ilosc jednostek czasu platnosci


Kolumna PaymentPeriodUnitID tabeli PhAuction

Definicja kolumny PaymentPeriodUnitID tabeli PhAuction

Name

PaymentPeriodUnitID

Code

PaymentPeriodUnitID

Data Type

NUMBER(10)

Mandatory

No

Comment

jednostka czasu platnosci


Kolumna RealizationPeriodQuantity tabeli PhAuction

Definicja kolumny RealizationPeriodQuantity tabeli PhAuction

Name

RealizationPeriodQuantity

Code

RealizationPeriodQuantity

Data Type

NUMBER(10)

Mandatory

No

Comment

ilosc jednostek czasu realizacji


Kolumna RealizationPeriodUnitID tabeli PhAuction

Definicja kolumny RealizationPeriodUnitID tabeli PhAuction

Name

RealizationPeriodUnitID

Code

RealizationPeriodUnitID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Lista kluczy tabeli PhAuction

Name

Code

Primary

Identifier_1

Identifier_1

X


Klucz Identifier_1 tabeli PhAuction

Definicja klucza Identifier_1 tabeli PhAuction

Name

Identifier_1

Code

Identifier_1

Primary

Yes

Comment